package com.crm.model.entity.customerManager;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CustomerRawDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CustomerRawDataExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCustomerRawDataIdIsNull() {
            addCriterion("customer_raw_data_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdIsNotNull() {
            addCriterion("customer_raw_data_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdEqualTo(String value) {
            addCriterion("customer_raw_data_id =", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdNotEqualTo(String value) {
            addCriterion("customer_raw_data_id <>", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdGreaterThan(String value) {
            addCriterion("customer_raw_data_id >", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdGreaterThanOrEqualTo(String value) {
            addCriterion("customer_raw_data_id >=", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdLessThan(String value) {
            addCriterion("customer_raw_data_id <", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdLessThanOrEqualTo(String value) {
            addCriterion("customer_raw_data_id <=", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdLike(String value) {
            addCriterion("customer_raw_data_id like", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdNotLike(String value) {
            addCriterion("customer_raw_data_id not like", value, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdIn(List<String> values) {
            addCriterion("customer_raw_data_id in", values, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdNotIn(List<String> values) {
            addCriterion("customer_raw_data_id not in", values, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdBetween(String value1, String value2) {
            addCriterion("customer_raw_data_id between", value1, value2, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCustomerRawDataIdNotBetween(String value1, String value2) {
            addCriterion("customer_raw_data_id not between", value1, value2, "customerRawDataId");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andOwnerIsNull() {
            addCriterion("owner is null");
            return (Criteria) this;
        }

        public Criteria andOwnerIsNotNull() {
            addCriterion("owner is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerEqualTo(String value) {
            addCriterion("owner =", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotEqualTo(String value) {
            addCriterion("owner <>", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerGreaterThan(String value) {
            addCriterion("owner >", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("owner >=", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLessThan(String value) {
            addCriterion("owner <", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLessThanOrEqualTo(String value) {
            addCriterion("owner <=", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLike(String value) {
            addCriterion("owner like", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotLike(String value) {
            addCriterion("owner not like", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerIn(List<String> values) {
            addCriterion("owner in", values, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotIn(List<String> values) {
            addCriterion("owner not in", values, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerBetween(String value1, String value2) {
            addCriterion("owner between", value1, value2, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotBetween(String value1, String value2) {
            addCriterion("owner not between", value1, value2, "owner");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberIsNull() {
            addCriterion("customer_number is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberIsNotNull() {
            addCriterion("customer_number is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberEqualTo(String value) {
            addCriterion("customer_number =", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotEqualTo(String value) {
            addCriterion("customer_number <>", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberGreaterThan(String value) {
            addCriterion("customer_number >", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberGreaterThanOrEqualTo(String value) {
            addCriterion("customer_number >=", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberLessThan(String value) {
            addCriterion("customer_number <", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberLessThanOrEqualTo(String value) {
            addCriterion("customer_number <=", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberLike(String value) {
            addCriterion("customer_number like", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotLike(String value) {
            addCriterion("customer_number not like", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberIn(List<String> values) {
            addCriterion("customer_number in", values, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotIn(List<String> values) {
            addCriterion("customer_number not in", values, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberBetween(String value1, String value2) {
            addCriterion("customer_number between", value1, value2, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotBetween(String value1, String value2) {
            addCriterion("customer_number not between", value1, value2, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeIsNull() {
            addCriterion("unified_social_credit_code is null");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeIsNotNull() {
            addCriterion("unified_social_credit_code is not null");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeEqualTo(String value) {
            addCriterion("unified_social_credit_code =", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotEqualTo(String value) {
            addCriterion("unified_social_credit_code <>", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeGreaterThan(String value) {
            addCriterion("unified_social_credit_code >", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeGreaterThanOrEqualTo(String value) {
            addCriterion("unified_social_credit_code >=", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLessThan(String value) {
            addCriterion("unified_social_credit_code <", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLessThanOrEqualTo(String value) {
            addCriterion("unified_social_credit_code <=", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLike(String value) {
            addCriterion("unified_social_credit_code like", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotLike(String value) {
            addCriterion("unified_social_credit_code not like", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeIn(List<String> values) {
            addCriterion("unified_social_credit_code in", values, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotIn(List<String> values) {
            addCriterion("unified_social_credit_code not in", values, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeBetween(String value1, String value2) {
            addCriterion("unified_social_credit_code between", value1, value2, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotBetween(String value1, String value2) {
            addCriterion("unified_social_credit_code not between", value1, value2, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andDealStatusIsNull() {
            addCriterion("deal_status is null");
            return (Criteria) this;
        }

        public Criteria andDealStatusIsNotNull() {
            addCriterion("deal_status is not null");
            return (Criteria) this;
        }

        public Criteria andDealStatusEqualTo(String value) {
            addCriterion("deal_status =", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotEqualTo(String value) {
            addCriterion("deal_status <>", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusGreaterThan(String value) {
            addCriterion("deal_status >", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusGreaterThanOrEqualTo(String value) {
            addCriterion("deal_status >=", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusLessThan(String value) {
            addCriterion("deal_status <", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusLessThanOrEqualTo(String value) {
            addCriterion("deal_status <=", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusLike(String value) {
            addCriterion("deal_status like", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotLike(String value) {
            addCriterion("deal_status not like", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusIn(List<String> values) {
            addCriterion("deal_status in", values, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotIn(List<String> values) {
            addCriterion("deal_status not in", values, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusBetween(String value1, String value2) {
            addCriterion("deal_status between", value1, value2, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotBetween(String value1, String value2) {
            addCriterion("deal_status not between", value1, value2, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelIsNull() {
            addCriterion("customer_level is null");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelIsNotNull() {
            addCriterion("customer_level is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelEqualTo(String value) {
            addCriterion("customer_level =", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotEqualTo(String value) {
            addCriterion("customer_level <>", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelGreaterThan(String value) {
            addCriterion("customer_level >", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelGreaterThanOrEqualTo(String value) {
            addCriterion("customer_level >=", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelLessThan(String value) {
            addCriterion("customer_level <", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelLessThanOrEqualTo(String value) {
            addCriterion("customer_level <=", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelLike(String value) {
            addCriterion("customer_level like", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotLike(String value) {
            addCriterion("customer_level not like", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelIn(List<String> values) {
            addCriterion("customer_level in", values, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotIn(List<String> values) {
            addCriterion("customer_level not in", values, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelBetween(String value1, String value2) {
            addCriterion("customer_level between", value1, value2, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotBetween(String value1, String value2) {
            addCriterion("customer_level not between", value1, value2, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusIsNull() {
            addCriterion("customer_status is null");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusIsNotNull() {
            addCriterion("customer_status is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusEqualTo(String value) {
            addCriterion("customer_status =", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusNotEqualTo(String value) {
            addCriterion("customer_status <>", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusGreaterThan(String value) {
            addCriterion("customer_status >", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusGreaterThanOrEqualTo(String value) {
            addCriterion("customer_status >=", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusLessThan(String value) {
            addCriterion("customer_status <", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusLessThanOrEqualTo(String value) {
            addCriterion("customer_status <=", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusLike(String value) {
            addCriterion("customer_status like", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusNotLike(String value) {
            addCriterion("customer_status not like", value, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusIn(List<String> values) {
            addCriterion("customer_status in", values, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusNotIn(List<String> values) {
            addCriterion("customer_status not in", values, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusBetween(String value1, String value2) {
            addCriterion("customer_status between", value1, value2, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerStatusNotBetween(String value1, String value2) {
            addCriterion("customer_status not between", value1, value2, "customerStatus");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIsNull() {
            addCriterion("customer_type is null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIsNotNull() {
            addCriterion("customer_type is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeEqualTo(String value) {
            addCriterion("customer_type =", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotEqualTo(String value) {
            addCriterion("customer_type <>", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeGreaterThan(String value) {
            addCriterion("customer_type >", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_type >=", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLessThan(String value) {
            addCriterion("customer_type <", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLessThanOrEqualTo(String value) {
            addCriterion("customer_type <=", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLike(String value) {
            addCriterion("customer_type like", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotLike(String value) {
            addCriterion("customer_type not like", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIn(List<String> values) {
            addCriterion("customer_type in", values, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotIn(List<String> values) {
            addCriterion("customer_type not in", values, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeBetween(String value1, String value2) {
            addCriterion("customer_type between", value1, value2, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotBetween(String value1, String value2) {
            addCriterion("customer_type not between", value1, value2, "customerType");
            return (Criteria) this;
        }

        public Criteria andMemberIsNull() {
            addCriterion("member is null");
            return (Criteria) this;
        }

        public Criteria andMemberIsNotNull() {
            addCriterion("member is not null");
            return (Criteria) this;
        }

        public Criteria andMemberEqualTo(String value) {
            addCriterion("member =", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberNotEqualTo(String value) {
            addCriterion("member <>", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberGreaterThan(String value) {
            addCriterion("member >", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberGreaterThanOrEqualTo(String value) {
            addCriterion("member >=", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberLessThan(String value) {
            addCriterion("member <", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberLessThanOrEqualTo(String value) {
            addCriterion("member <=", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberLike(String value) {
            addCriterion("member like", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberNotLike(String value) {
            addCriterion("member not like", value, "member");
            return (Criteria) this;
        }

        public Criteria andMemberIn(List<String> values) {
            addCriterion("member in", values, "member");
            return (Criteria) this;
        }

        public Criteria andMemberNotIn(List<String> values) {
            addCriterion("member not in", values, "member");
            return (Criteria) this;
        }

        public Criteria andMemberBetween(String value1, String value2) {
            addCriterion("member between", value1, value2, "member");
            return (Criteria) this;
        }

        public Criteria andMemberNotBetween(String value1, String value2) {
            addCriterion("member not between", value1, value2, "member");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameIsNull() {
            addCriterion("primary_contact_name is null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameIsNotNull() {
            addCriterion("primary_contact_name is not null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameEqualTo(String value) {
            addCriterion("primary_contact_name =", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameNotEqualTo(String value) {
            addCriterion("primary_contact_name <>", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameGreaterThan(String value) {
            addCriterion("primary_contact_name >", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameGreaterThanOrEqualTo(String value) {
            addCriterion("primary_contact_name >=", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameLessThan(String value) {
            addCriterion("primary_contact_name <", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameLessThanOrEqualTo(String value) {
            addCriterion("primary_contact_name <=", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameLike(String value) {
            addCriterion("primary_contact_name like", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameNotLike(String value) {
            addCriterion("primary_contact_name not like", value, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameIn(List<String> values) {
            addCriterion("primary_contact_name in", values, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameNotIn(List<String> values) {
            addCriterion("primary_contact_name not in", values, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameBetween(String value1, String value2) {
            addCriterion("primary_contact_name between", value1, value2, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactNameNotBetween(String value1, String value2) {
            addCriterion("primary_contact_name not between", value1, value2, "primaryContactName");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneIsNull() {
            addCriterion("primary_contact_phone is null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneIsNotNull() {
            addCriterion("primary_contact_phone is not null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneEqualTo(String value) {
            addCriterion("primary_contact_phone =", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneNotEqualTo(String value) {
            addCriterion("primary_contact_phone <>", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneGreaterThan(String value) {
            addCriterion("primary_contact_phone >", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("primary_contact_phone >=", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneLessThan(String value) {
            addCriterion("primary_contact_phone <", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneLessThanOrEqualTo(String value) {
            addCriterion("primary_contact_phone <=", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneLike(String value) {
            addCriterion("primary_contact_phone like", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneNotLike(String value) {
            addCriterion("primary_contact_phone not like", value, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneIn(List<String> values) {
            addCriterion("primary_contact_phone in", values, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneNotIn(List<String> values) {
            addCriterion("primary_contact_phone not in", values, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneBetween(String value1, String value2) {
            addCriterion("primary_contact_phone between", value1, value2, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPhoneNotBetween(String value1, String value2) {
            addCriterion("primary_contact_phone not between", value1, value2, "primaryContactPhone");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionIsNull() {
            addCriterion("primary_contact_position is null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionIsNotNull() {
            addCriterion("primary_contact_position is not null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionEqualTo(String value) {
            addCriterion("primary_contact_position =", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionNotEqualTo(String value) {
            addCriterion("primary_contact_position <>", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionGreaterThan(String value) {
            addCriterion("primary_contact_position >", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionGreaterThanOrEqualTo(String value) {
            addCriterion("primary_contact_position >=", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionLessThan(String value) {
            addCriterion("primary_contact_position <", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionLessThanOrEqualTo(String value) {
            addCriterion("primary_contact_position <=", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionLike(String value) {
            addCriterion("primary_contact_position like", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionNotLike(String value) {
            addCriterion("primary_contact_position not like", value, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionIn(List<String> values) {
            addCriterion("primary_contact_position in", values, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionNotIn(List<String> values) {
            addCriterion("primary_contact_position not in", values, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionBetween(String value1, String value2) {
            addCriterion("primary_contact_position between", value1, value2, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactPositionNotBetween(String value1, String value2) {
            addCriterion("primary_contact_position not between", value1, value2, "primaryContactPosition");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailIsNull() {
            addCriterion("primary_contact_email is null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailIsNotNull() {
            addCriterion("primary_contact_email is not null");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailEqualTo(String value) {
            addCriterion("primary_contact_email =", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailNotEqualTo(String value) {
            addCriterion("primary_contact_email <>", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailGreaterThan(String value) {
            addCriterion("primary_contact_email >", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailGreaterThanOrEqualTo(String value) {
            addCriterion("primary_contact_email >=", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailLessThan(String value) {
            addCriterion("primary_contact_email <", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailLessThanOrEqualTo(String value) {
            addCriterion("primary_contact_email <=", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailLike(String value) {
            addCriterion("primary_contact_email like", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailNotLike(String value) {
            addCriterion("primary_contact_email not like", value, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailIn(List<String> values) {
            addCriterion("primary_contact_email in", values, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailNotIn(List<String> values) {
            addCriterion("primary_contact_email not in", values, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailBetween(String value1, String value2) {
            addCriterion("primary_contact_email between", value1, value2, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andPrimaryContactEmailNotBetween(String value1, String value2) {
            addCriterion("primary_contact_email not between", value1, value2, "primaryContactEmail");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneIsNull() {
            addCriterion("enterprise_external_phone is null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneIsNotNull() {
            addCriterion("enterprise_external_phone is not null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneEqualTo(String value) {
            addCriterion("enterprise_external_phone =", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotEqualTo(String value) {
            addCriterion("enterprise_external_phone <>", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneGreaterThan(String value) {
            addCriterion("enterprise_external_phone >", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("enterprise_external_phone >=", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneLessThan(String value) {
            addCriterion("enterprise_external_phone <", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneLessThanOrEqualTo(String value) {
            addCriterion("enterprise_external_phone <=", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneLike(String value) {
            addCriterion("enterprise_external_phone like", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotLike(String value) {
            addCriterion("enterprise_external_phone not like", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneIn(List<String> values) {
            addCriterion("enterprise_external_phone in", values, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotIn(List<String> values) {
            addCriterion("enterprise_external_phone not in", values, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneBetween(String value1, String value2) {
            addCriterion("enterprise_external_phone between", value1, value2, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotBetween(String value1, String value2) {
            addCriterion("enterprise_external_phone not between", value1, value2, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneIsNull() {
            addCriterion("mobile_phone is null");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneIsNotNull() {
            addCriterion("mobile_phone is not null");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneEqualTo(String value) {
            addCriterion("mobile_phone =", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotEqualTo(String value) {
            addCriterion("mobile_phone <>", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneGreaterThan(String value) {
            addCriterion("mobile_phone >", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneGreaterThanOrEqualTo(String value) {
            addCriterion("mobile_phone >=", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLessThan(String value) {
            addCriterion("mobile_phone <", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLessThanOrEqualTo(String value) {
            addCriterion("mobile_phone <=", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLike(String value) {
            addCriterion("mobile_phone like", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotLike(String value) {
            addCriterion("mobile_phone not like", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneIn(List<String> values) {
            addCriterion("mobile_phone in", values, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotIn(List<String> values) {
            addCriterion("mobile_phone not in", values, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneBetween(String value1, String value2) {
            addCriterion("mobile_phone between", value1, value2, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotBetween(String value1, String value2) {
            addCriterion("mobile_phone not between", value1, value2, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerIsNull() {
            addCriterion("internal_training_owner is null");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerIsNotNull() {
            addCriterion("internal_training_owner is not null");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerEqualTo(String value) {
            addCriterion("internal_training_owner =", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerNotEqualTo(String value) {
            addCriterion("internal_training_owner <>", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerGreaterThan(String value) {
            addCriterion("internal_training_owner >", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("internal_training_owner >=", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerLessThan(String value) {
            addCriterion("internal_training_owner <", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerLessThanOrEqualTo(String value) {
            addCriterion("internal_training_owner <=", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerLike(String value) {
            addCriterion("internal_training_owner like", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerNotLike(String value) {
            addCriterion("internal_training_owner not like", value, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerIn(List<String> values) {
            addCriterion("internal_training_owner in", values, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerNotIn(List<String> values) {
            addCriterion("internal_training_owner not in", values, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerBetween(String value1, String value2) {
            addCriterion("internal_training_owner between", value1, value2, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andInternalTrainingOwnerNotBetween(String value1, String value2) {
            addCriterion("internal_training_owner not between", value1, value2, "internalTrainingOwner");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptIsNull() {
            addCriterion("number_of_finance_dept is null");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptIsNotNull() {
            addCriterion("number_of_finance_dept is not null");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptEqualTo(String value) {
            addCriterion("number_of_finance_dept =", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptNotEqualTo(String value) {
            addCriterion("number_of_finance_dept <>", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptGreaterThan(String value) {
            addCriterion("number_of_finance_dept >", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptGreaterThanOrEqualTo(String value) {
            addCriterion("number_of_finance_dept >=", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptLessThan(String value) {
            addCriterion("number_of_finance_dept <", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptLessThanOrEqualTo(String value) {
            addCriterion("number_of_finance_dept <=", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptLike(String value) {
            addCriterion("number_of_finance_dept like", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptNotLike(String value) {
            addCriterion("number_of_finance_dept not like", value, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptIn(List<String> values) {
            addCriterion("number_of_finance_dept in", values, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptNotIn(List<String> values) {
            addCriterion("number_of_finance_dept not in", values, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptBetween(String value1, String value2) {
            addCriterion("number_of_finance_dept between", value1, value2, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfFinanceDeptNotBetween(String value1, String value2) {
            addCriterion("number_of_finance_dept not between", value1, value2, "numberOfFinanceDept");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersIsNull() {
            addCriterion("number_of_members is null");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersIsNotNull() {
            addCriterion("number_of_members is not null");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersEqualTo(String value) {
            addCriterion("number_of_members =", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersNotEqualTo(String value) {
            addCriterion("number_of_members <>", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersGreaterThan(String value) {
            addCriterion("number_of_members >", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersGreaterThanOrEqualTo(String value) {
            addCriterion("number_of_members >=", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersLessThan(String value) {
            addCriterion("number_of_members <", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersLessThanOrEqualTo(String value) {
            addCriterion("number_of_members <=", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersLike(String value) {
            addCriterion("number_of_members like", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersNotLike(String value) {
            addCriterion("number_of_members not like", value, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersIn(List<String> values) {
            addCriterion("number_of_members in", values, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersNotIn(List<String> values) {
            addCriterion("number_of_members not in", values, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersBetween(String value1, String value2) {
            addCriterion("number_of_members between", value1, value2, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersNotBetween(String value1, String value2) {
            addCriterion("number_of_members not between", value1, value2, "numberOfMembers");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsIsNull() {
            addCriterion("number_of_members_cards is null");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsIsNotNull() {
            addCriterion("number_of_members_cards is not null");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsEqualTo(String value) {
            addCriterion("number_of_members_cards =", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsNotEqualTo(String value) {
            addCriterion("number_of_members_cards <>", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsGreaterThan(String value) {
            addCriterion("number_of_members_cards >", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsGreaterThanOrEqualTo(String value) {
            addCriterion("number_of_members_cards >=", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsLessThan(String value) {
            addCriterion("number_of_members_cards <", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsLessThanOrEqualTo(String value) {
            addCriterion("number_of_members_cards <=", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsLike(String value) {
            addCriterion("number_of_members_cards like", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsNotLike(String value) {
            addCriterion("number_of_members_cards not like", value, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsIn(List<String> values) {
            addCriterion("number_of_members_cards in", values, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsNotIn(List<String> values) {
            addCriterion("number_of_members_cards not in", values, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsBetween(String value1, String value2) {
            addCriterion("number_of_members_cards between", value1, value2, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfMembersCardsNotBetween(String value1, String value2) {
            addCriterion("number_of_members_cards not between", value1, value2, "numberOfMembersCards");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsIsNull() {
            addCriterion("number_of_contacts is null");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsIsNotNull() {
            addCriterion("number_of_contacts is not null");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsEqualTo(String value) {
            addCriterion("number_of_contacts =", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsNotEqualTo(String value) {
            addCriterion("number_of_contacts <>", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsGreaterThan(String value) {
            addCriterion("number_of_contacts >", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsGreaterThanOrEqualTo(String value) {
            addCriterion("number_of_contacts >=", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsLessThan(String value) {
            addCriterion("number_of_contacts <", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsLessThanOrEqualTo(String value) {
            addCriterion("number_of_contacts <=", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsLike(String value) {
            addCriterion("number_of_contacts like", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsNotLike(String value) {
            addCriterion("number_of_contacts not like", value, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsIn(List<String> values) {
            addCriterion("number_of_contacts in", values, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsNotIn(List<String> values) {
            addCriterion("number_of_contacts not in", values, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsBetween(String value1, String value2) {
            addCriterion("number_of_contacts between", value1, value2, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andNumberOfContactsNotBetween(String value1, String value2) {
            addCriterion("number_of_contacts not between", value1, value2, "numberOfContacts");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardIsNull() {
            addCriterion("invalid_membership_card is null");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardIsNotNull() {
            addCriterion("invalid_membership_card is not null");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardEqualTo(String value) {
            addCriterion("invalid_membership_card =", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardNotEqualTo(String value) {
            addCriterion("invalid_membership_card <>", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardGreaterThan(String value) {
            addCriterion("invalid_membership_card >", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardGreaterThanOrEqualTo(String value) {
            addCriterion("invalid_membership_card >=", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardLessThan(String value) {
            addCriterion("invalid_membership_card <", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardLessThanOrEqualTo(String value) {
            addCriterion("invalid_membership_card <=", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardLike(String value) {
            addCriterion("invalid_membership_card like", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardNotLike(String value) {
            addCriterion("invalid_membership_card not like", value, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardIn(List<String> values) {
            addCriterion("invalid_membership_card in", values, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardNotIn(List<String> values) {
            addCriterion("invalid_membership_card not in", values, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardBetween(String value1, String value2) {
            addCriterion("invalid_membership_card between", value1, value2, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andInvalidMembershipCardNotBetween(String value1, String value2) {
            addCriterion("invalid_membership_card not between", value1, value2, "invalidMembershipCard");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNull() {
            addCriterion("update_people_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNotNull() {
            addCriterion("update_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdEqualTo(String value) {
            addCriterion("update_people_id =", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotEqualTo(String value) {
            addCriterion("update_people_id <>", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThan(String value) {
            addCriterion("update_people_id >", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_people_id >=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThan(String value) {
            addCriterion("update_people_id <", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("update_people_id <=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLike(String value) {
            addCriterion("update_people_id like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotLike(String value) {
            addCriterion("update_people_id not like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIn(List<String> values) {
            addCriterion("update_people_id in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotIn(List<String> values) {
            addCriterion("update_people_id not in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdBetween(String value1, String value2) {
            addCriterion("update_people_id between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("update_people_id not between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNull() {
            addCriterion("delete_status is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNotNull() {
            addCriterion("delete_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusEqualTo(Short value) {
            addCriterion("delete_status =", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotEqualTo(Short value) {
            addCriterion("delete_status <>", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThan(Short value) {
            addCriterion("delete_status >", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("delete_status >=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThan(Short value) {
            addCriterion("delete_status <", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThanOrEqualTo(Short value) {
            addCriterion("delete_status <=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIn(List<Short> values) {
            addCriterion("delete_status in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotIn(List<Short> values) {
            addCriterion("delete_status not in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusBetween(Short value1, Short value2) {
            addCriterion("delete_status between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotBetween(Short value1, Short value2) {
            addCriterion("delete_status not between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andIdentificationIsNull() {
            addCriterion("identification is null");
            return (Criteria) this;
        }

        public Criteria andIdentificationIsNotNull() {
            addCriterion("identification is not null");
            return (Criteria) this;
        }

        public Criteria andIdentificationEqualTo(String value) {
            addCriterion("identification =", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotEqualTo(String value) {
            addCriterion("identification <>", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationGreaterThan(String value) {
            addCriterion("identification >", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationGreaterThanOrEqualTo(String value) {
            addCriterion("identification >=", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationLessThan(String value) {
            addCriterion("identification <", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationLessThanOrEqualTo(String value) {
            addCriterion("identification <=", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationLike(String value) {
            addCriterion("identification like", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotLike(String value) {
            addCriterion("identification not like", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationIn(List<String> values) {
            addCriterion("identification in", values, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotIn(List<String> values) {
            addCriterion("identification not in", values, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationBetween(String value1, String value2) {
            addCriterion("identification between", value1, value2, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotBetween(String value1, String value2) {
            addCriterion("identification not between", value1, value2, "identification");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}